Copy Sheet
Description
Google Spreadsheet: Copy Sheet Plugin Step, copies a sheet from one spreadsheet to same or another spreadsheet on Google drive.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection: | Refer Prerequisites and References above to get the connection attributes. | |
| 2 | Client ID | Specify Client ID of the Google application. The data type is String. This field is mandatory. |
| Client Secret: | ||
| 3 | Accept Values from fields | Leave checkbox unchecked to accept Client Secret value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 4 | Client Secret | Specify Client Secret of the Google application. If checkbox above is enabled Client Secret field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Client Secret field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| Refresh Token: | ||
| 5 | Accept Values from fields | Leave checkbox unchecked to accept Secret Key value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 6 | Refresh Token | Specify a Refresh Token to obtain a new Access Token. Note:Refresh Token expires if idle for 6 months. If checkbox above is enabled Refresh Token field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Refresh Token field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| 7 | Button: Test Connection | Verifies whether the connection is established or not. Note: For the purpose of verification fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state; only static values and environment variables are allowed. |
| Input Fields: | ||
| 1 | Source Spreadsheet ID | Specify the Source Spreadsheet ID from which the sheet is to be copied. The data type is String. This field is mandatory. Note: To get a spreadsheet ID:In the URL, the spreadsheet ID is the value between "/d/" and "/edit" in the URL of the spreadsheet, as shown in the following image:  For example, consider the following URL that refers a Google Sheets spreadsheet: https://docs.google.com/spreadsheets/d/1CJnkal5pj3SLpv-HdmyguX/edit#gid=0 Then the Spreadsheet ID is 1CJnkal5pj3SLpv- HdmyguX. |
| 2 | Sheet ID | Specify the sheet ID of a sheet that is to be copied. The data type is String. This field is mandatory. Note: To get a sheet ID that is to be copied: i. Open the Excel book and click on the Sheet ID you want to copy. ii. Copy the gid. For example, in the following URL, the sheet ID is, gid=1858077604  |
| 3 | Destination Spreadsheet ID | Specify the destination spreadsheet Id to which the sheet is to be copied. Follow the same method to fetch Spreadsheet ID as mentioned for Source Spreadsheet ID. The data type is String. This field is mandatory. |